/*
    Project Milestone 3
    by Lorenzo Miori [Lorenzo.Miori@stud-inf.unibz.it,
    Matteo Angriman [Matteo.Angriman@stud-inf.unibz.it],
    Nick Preda [Nicolae.Preda@stud-inf.unibz.it]
*/

package DB;
import java.sql.Connection;
import static DB.GenericDBInterface.*;
/**
 *
 * @author matteo
 */
public class GuestDB extends GenericTableInterface {
    /*Declaration of the attributes*/
    public static final String GUEST_TABLE_NAME = "guest";
    public static final String GUEST_RELATED_CUSTOMER = "related_customer";
    public static final String GUEST_ID = "guest_id";
    public static final String GUEST_ID_CARD_NUMBER = "idcard_number";
    public static final String GUEST_NAME = "guest_name";
    public static final String GUEST_ORDER[] = {GUEST_ID, GUEST_RELATED_CUSTOMER, GUEST_ID_CARD_NUMBER, GUEST_NAME};
    
    /*Attribute types*/
    public static final int[] GUEST_TYPE = {INT, INT, STRING, STRING};
    
    public GuestDB(Connection dbConnection){
        super(dbConnection, GUEST_TYPE, GUEST_ID, GUEST_TABLE_NAME, GUEST_ORDER);
    }
    
}
